EMT Practice Test

1. Question Content...

---

Question1: Which statement is true regarding the SET statement?

Question2: You submit a program and the SAS log is shown below:

Which statement is true regarding the submitted program?

Question3: Which LIBNAME statement has the correct syntax for accessing SAS data sets?

Question4: What is the result of submitting the program below?
proc contents data=revenue;
run;

Question5: The data set SASHELP. CARS contains information on different vehicles. How do you correctly write the observations with Type of 'SUV' to the suv data set and Type of 'Sedan' to the sedans data set?

Question6: Which statement is true regarding a variable?

Question7: Given the STUDENTS data set below:

What will be the values for First. State and Last. State for Ellen's observation?

Question8: Which step temporarily assign a format to the sales variable?

Question9: Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

Question10: Which two data sets are permanent?

Question11: Which statement is true when creating two SAS data sets with a DATA step?

Question12: Given the following DATA step:

What is the value of average?
Enter your numeric answer in the space above.

Question13: Which PROC PRINT step correctly displays only the first 10 observations in the data set?

Question14: What is the default sort order of PROC SORT?

Question15: The sashelp. class data set has 19 observations.
Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?

Question16: The following program is summited:

The following report is created:

However, the desired report is shown below:

What change is needed to display the desired formatted values for the Answer varia

Question17: Which statement is true regarding the DATA step?

Question18: Given the following SAS program:

What footnotes appear for the second PROC PRINY report?

Question19: What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

Question20: Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?

Question21: Which option renames the variable Name to StudentName when reading the ClassRoster data set?

Question22: Which statement is true regarding the XLSX engine in the LIBNAME statement?

Question23: Which PROC PRINT statement controls the order of the variables displayed in the report?

Question24: Which PROC SORT option allows you to create an output data set of the sorted data?

Question25: Which statement is true regarding a DATA step concatenation?

Question26: How does SAS display missing values?

Question27: Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below:

Question28: When the following code is submitted, execution fails.

Why does the execution fail?

Question29: Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?

Question30: Which step reads the SASHELP. BASEBALL data set and creates the temporary data set CATCHERS?

Question31: Which assignment statement uses the SUBSTR function to extract the four-digit year from the value of date?
data days;
date="02Apr2019";
insert-statement-here
run;

Question32: Given the following code:

Which variables are created with the BY statement?

Question33: Given the PATIENT and VISIT data sets and the DATA step shown below:
PATIENT

VISIT


How many observations are created in the ALLVISITS data set?

Question34: The data set Snacks contains three variables (productName, Flavor, and Price). Given the program shown below:

What is the type and length of SnackType?